	
/****** Object:  Stored Procedure BulkOrderTerritoriesUpdate    Script Date: Wednesday, November 21, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spBulkOrderTerritoriesUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spBulkOrderTerritoriesUpdate]
GO

	
	

	
/******************************************************************************
**		File: 
**		Name: spBulkOrderTerritoriesUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 11/21/2007 1:52:43 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spBulkOrderTerritoriesUpdate
	@BulkOrderID int, 
	@TerritoryID int, 
	@HomeDelivered15Price money, 
	@CurrencyID int 
AS

UPDATE [BulkOrderTerritories] SET
	[HomeDelivered15Price] = @HomeDelivered15Price,
	[CurrencyID] = @CurrencyID
WHERE
	[BulkOrderID] = @BulkOrderID
	AND [TerritoryID] = @TerritoryID

GO
